SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
AND list_price BETWEEN '500000' AND '1000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 5
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Step into history at The Treetops, an extraordinary 4-bedroom, 2-bath home that was once part of the original Saint-Gaudens estate. This stunning property carries the spirit of the famed Cornish Art Colony, where master sculptor Augustus Saint-Gaudens and his creative circle found inspiration in the rolling hills of New Hampshire. Perched on a scenic private lot, this home offers a tranquil retreat surrounded by nature. A gentle stream winds through the property, adding to the peaceful ambiance, while garden spaces provide the perfect setting for cultivating beauty—just as artists once did in this very landscape. From the sun-drenched rooms to the charming historic details, The Treetops is a timeless escape that seamlessly blends past and present. Located just minutes from the Upper Valley, with easy access to both sides of the Connecticut River, this home offers the perfect balance of seclusion and convenience—close to Dartmouth College, world-class healthcare, vibrant arts, and year-round outdoor recreation. This is more than just a home; it's a living piece of history in one of New Hampshire’s most picturesque and storied communities. Opportunities like this are rare—don’t miss your chance to own a legacy!
Description:Very convenient location to all the amenities of the Upper Valley!! If you have horses and animals, or if you are thinking of getting animals, this property is for you! With open fields, a 7 stall barn (32' x 49'), a large private pond (20' deep at its deepest point), you can enjoy the sunsets and the view of your own farm from the rear deck, or the gazebo on the pond. The home has 2 bedrooms and 2 baths, with an open kitchen, dining, and living area. The kitchen has granite counter tops with a spacious island. The walkout lower level is fully finished with a large family room, one bedroom and a bath. There is a large detached 2 car garage (20'x36') with storage above, and an additional bay (28'x32') off the back. There are several garden spaces and established blueberry bushes. What a great property to call home. Come and turn your dreams into an address!! Delayed Showings. Showings will start at the public Open House on Saturday, March 8th from 10:00 AM to 12:00 Noon.
Description:Welcome to your brand-new home in Hanover! This beautifully designed new construction features a spacious open floor plan, ideal for both entertaining and enjoying peaceful nights at home. With convenient first-floor laundry hookups and a maintenance-free lifestyle, this home offers all the modern amenities you need. Hardwood floors, masterfully designed bathrooms with custom tile showers, a spectacular kitchen with Quartz countertops, fully appliances kitchens, and tile back splash. Primary Suite is stunning and offers lots of privacy from the rest of the home. Located just minutes from Dartmouth College, Dartmouth-Hitchcock Medical Center, and several ski resorts, it provides unmatched convenience and accessibility. Whether you're working on campus or exploring the vibrant Hanover area, this location can't be beat. Don't miss the chance to make this your new home—ready for immediate occupancy! Schedule a showing today and start imagining your life in this dream home. Home is complete and move-in ready! Last unit left! The seller is a licensed New Hampshire real estate broker.
Description:"The Rock Ridge Community" offering 326 pristine acres of nature, trails, and riverfront access to all that the Upper Valley has to offer. The Upper Valley's Premier Neighborhood, all New Construction. This brand new home offers 3 bedroom, 2.5 bath home. Open concept living with hardwood floors, granite countertops, tiled baths and flexible floor plan. Share the community garden, enjoy socials at the Farmhouse, and the privileges that an HOA provides. Close to I89, DHMC, Dartmouth College, Lebanon 6 Movie Theater, Downtown and plenty of shopping. House is currently under construction with an estimated completion date of April 30th. All showings must be after 4pm weekdays or weekend, this is an active construction area please no unsupervised visits. Pictures in MLS are a facsimile of house being built.
Description:Country living at its best! Stunning log, cape-style home located on 5+ acres. Park-like grounds with a beautiful view! Enjoy the sunsets from your private back deck. There's a fenced in area for the dogs and a pasture field beyond. This home is a true New England log home with 3 bedrooms and 2 bathrooms. The open living area has a beautiful brick and granite hearth with a woodstove and cathedral ceilings. Upstairs there is a loft office area, a large bedroom and bath. The full unfinished basement has a woodstove and lots of storage. Recently the farmers porched was enclosed with new windows and insulated for additional living space. The 3 bay garage is finished and heated with a woodstove. There is hot and cold water with a shop area. Upstairs is additional storage. Also included is a barn that is 24 x 50 with 13' clearance. Plenty of wildlife and trails on the property. Enjoy snowmobiling, X country skiing and horseback riding access. Also apple trees and raspberry bushes. Close to Crystal Lake too.